How to bulk update prices in a Webflow CMS collection
Supplier raised prices 8%. Sale starts Monday. Currency rounding changed. Whatever the trigger, you now need to touch a number field on every item in a collection, and Webflow's UI wants you to do it one item at a time.
The spreadsheet-export route
Export the collection to CSV, add a formula column (=A2*1.08), paste values back, re-import mapped by Item ID. It works, with the usual caveats: Excel may reformat your numbers (decimal commas vs points are a classic for European stores), the import has no preview, and there's no undo. If you go this route: keep the original export as backup, spot-check ten items after import, and republish deliberately.
The automation route
If prices live in an external system and change weekly, don't do this by hand at all. A Make scenario or a script against the Webflow Data API can patch items in batches of up to 100 and run on a schedule. Set it up once, respect the rate limits, done. This is the right answer for recurring syncs and the wrong answer for a one-time "everything +8%".
The math-action route
Bulkman treats this as a one-liner. Open the collection, open the Price column's math action, choose +8%, and preview old → new for every item. Nothing has been written yet. Apply shows the full diff, takes an automatic snapshot, then writes only the price field on only the changed items. Publish pushes exactly those items live. Boss says the increase was actually 5%? Restore the snapshot, run it again.
Round-tripping through Excel to multiply a column by 1.08 is a lot of ceremony for one multiplication. Do it where the data lives.